sfc1
Pradeep H C
2024-10-10
Snowflake environment setup
Creating snowflake trail account(02:41)
Snowflake web console introduction part1(06:14)
Snowflake web console introduction part2(03:54)
Web console limitation(01:17)
Creating database and table intro to sample data.(02:18)
Section revise notes
Snowflake architecture
Snowflake architecture introduction.(02:16)
Shared disk architecture.(01:18)
Shared nothing architecture part 1(02:33)
Shared nothing architecture part 2(02:40)
Snowflake architecture revisit.(02:02)
The impact.(00:58)
Further reading Resources
Caching in snowflake
Introduction.(00:28)
[Architecture demo] Caching in snowflake.(18:19)
[Architecture demo] Caching revisit.(03:47)
[Architecture demo] Lessons learned.(03:47)
Clarifications(08:30)
Clustering
introduction.(00:29)
Query processing in snowflake.(04:04)
Micro partitions in snowflake.(01:54)
Micro partitions depth.(02:25)
[Demo] Applying clustering brief intro.(05:45)
Clustering -- deep dive
Section introduction.(00:37)
[Demo] Checking clustering information(06:01)
[Demo] How clustering works.(05:59)
[Demo] Improve performance without applying clustering(02:22)
[Demo] Manual re-clustering(03:16)
[Demo] How to choose clustering keys.(04:28)
Section Recap.(01:49)
Snowflake clustering documentation.
Virtual warehouse
Introduction to virtual warehouse.(04:16)
Virtual warehouse creation.(08:52)
Scaling policy(03:30)
Performance tuning and DB characterstics
What is performance tuning in snowflake.(08:59)
How query optimization works.(04:10)
Concurrency control.(15:28)
[Demo] How update transaction works.(02:33)
[Demo] No constraints.(04:19)
Q/A(11:36)
Snowflake UI overview
Introduction(01:21)
Snowsight_overview_part1(10:25)
Snowsight_overview_part2(07:18)
Query acceleration service
Introduction(01:20)
Creating warehouse with QAS(02:22)
Problem statement(05:47)
QAS- Solution(03:39)
QAS- Demo(03:10)
QAS- scale factor(02:20)
QAS- Eligible queries(04:03)
Importent points(01:52)
Search optimization service
SOS introduction(01:49)
Problem statement(04:37)
SOS: Scenario-1(07:36)
SOS: Scenario-2(06:27)
SOS: Scenario-3(05:47)
How SOS works(03:55)
SOS: Summary(01:49)
Query optimisation options(01:56)
Optimization - outlook
Basic understanding(06:49)
ScaleUp vs ScaleOut(02:08)
Query optimisation(06:36)
Storage considerations.(01:50)
As per documentation.(01:38)
Business model(03:23)
Warehouse monitor(03:28)
Warehouse monitor:Demo(05:22)
Budgets.(02:54)
Snowflake architecture basics
Virtual warehouse and UI
Performacne optimization
References
Snowflake trail account link
Quiz
Assignment
Snowflake SIGMOD paper
Snowflake architecture documentation
Quiz
Quize 2
Quiz
Snowflake CACHE
Further reading
Quiz
Quiz 2
clustering
Benefits of Defining Clustering Keys
What is clustering key
Considerations for Choosing Clustering for a Table
Strategies for Selecting Clustering Keys
Reclustering
Quiz
ASSIGNMENT FIX
Quiz from documentation
Snowfalke performance optimization
Quiz
References
QAS documentation
Quiz
Quiz
SOS snowflake documentation
Snowflake optimization
Warehouse resource monitor
Quiz
Snowflake virtual warehouse --outlook
Warehouse idle time intro(01:03)
Warehouse analogy(03:18)
Metadata views(08:21)
Snowflake warehouse dashboard
Calculating idle cost(07:46)
Adding dynamic filters(05:18)
Creating dashboard intro(06:06)
Warehouse utilization dashboard.(08:05)
Analysis by warehouse(04:51)
Analysis for under utilization(02:33)
Analysis for over utilization(04:36)
Building dashboard(01:30)
Leveraging snowsight(06:15)
Conclusion(01:31)
Quiz
Quiz
Total run time : 3.5 hrs
Number of lectures: 31 lectures
Quiz: 7 quiz
Questions : 64 questions
Total run time : 2 hrs
Number of lectures: 19 lectures
Quiz: 2 quiz
Questions : 17 questions
Total run time : 2.3 hrs
Number of lectures: 31 lectures
Quiz: 4 quiz
Questions : 32 questions
Snowflake dashboard
References
virtual warehouse
Created With
EdrawMind